Bentley Raceway and Cable Management CONNECT Edition Help

To Import Connection Data from an Excel File

  1. Open the drawing Equipment.dgn. (This example was created using the BRCM_EU_EN project).
  2. Select the Cable List Import from Excel option from the Bentley Raceway and Cable Management Detail Design taskbar.
  3. In the XLS-Import dialog, click in the XLS file field and click the Browse button to select the file.
  4. In the Open dialog, select the cable list file (CableList.xls) to import an click Open. (Folder ...\WorkSpace\BRCM Metric Example\Worksets\BRCM_EU_EN\Standards\BRCM\Documents).
  5. Type in Start (start line) value.
    Note: This represents the row which the cable list data begins.
  6. Type in End Row value.
    Note: This represents the end row of the reading process.
  7. The next step is to load the associated XML file for the interpretation of the Microsoft Excel table.
  8. Select the map file (IMPORT_Cablelist.xml) that corresponds with the cable list loaded in the previous steps. (Folder ...\WorkSpace\BRCM Metric Example\Worksets\BRCM_EU_EN\Standards\BRCM\Documents).
  9. When finished, click OK to display the XLS Import dialog. This shows you the cables to be imported.
  10. Click OK to display the Collaboration Manager.
  11. Click OK to display the Review Differences dialog. This syncs the file against what is currently in the project and displays the differences.

    When importing cables into a project, Bentley Raceway and Cable Management checks to see if unique cable ID's are imported. If duplicates is found it is rejected during import and change needs to be made.

  12. Select all of the cables and click Accept (except for any duplicates).
  13. Click Update to confirm the transfer
  14. Use Update Database to save to database.
Parent topic: Cable List Import from Excel (Detail Design)